There is a lot to consider! Maybe exploratory analysis can help!

• Where is the best place in the United States to run a dairy operation?
• What products are the most profitable?
• What are hazards to look out for during production to avoid recalls?

Introducing the milk produced by state from 1970 to 2017.

This data set includes 2400 rows with the variables:

• Region
• State
• Year
• Milk Produced

First we need to explore a little.

which.min(dairybystate$milk_produced)

## [1] 2199

which.max(dairybystate$milk_produced)

## [1] 2248

##       region  state year milk_produced
## 2199 Pacific Alaska 2013         3e+06

##       region      state year milk_produced
## 2248 Pacific California 2014    4.2339e+10

Let’s take a look at CA, NY, and WI:

Other things to consider:

• CA environmental laws are extreme, but everyone likes to pair cheese with wine
• NY land cost is expensive, but the urban demand is there
• WI dairy history is rich, but competition is high

Overall recommendation: Southcentral Wisconsin

USDA Dairy Data for Products - 18 years of average retail price and farm value - Each product has its own 18 x 4 table

USDA Dairy Product Consumption - 45 years of dairy consumption per capita divided by products

## # A tibble: 6 x 5
##    Year RetailPrice_Dollars FarmValue_Dollars FarmShare_Percent Product
##   <dbl>               <dbl>             <dbl>             <dbl> <chr>  
## 1  2000                2.14              1.03              48.1 Butter 
## 2  2001                2.68              1.52              56.7 Butter 
## 3  2002                2.22              0.99              44.6 Butter 
## 4  2003                2.05              1                 48.8 Butter 
## 5  2004                2.79              1.69              60.6 Butter 
## 6  2005                2.64              1.41              53.4 Butter

## NULL

• Get a contract with Kwik Twip to sell milk and butter
• Make your own specialty cheese and ice cream to sell online or store front
• Hire Becca to pair your cheeses with meat in charcuterie board / snacking application

In order to determine possible issues during the processes of products, we utilized the FDA food recall database listings from 2016-2020. These were procured as a .csv for 2018-2020, and scraped from archived FDA websites.

1914 entries once all years are merged. Variables include:

• Date (mm/dd/yyyy)
• Company Name
• Product Category
• Product Name
• Reason for Recall

For example, one entry was listed as Whole Foods, instead of a product category, so I decided to rely on filtering I performed instead.

I scraped the names of dairy products and cheese listed in an HTML table on wikipedia to filter the dataset.

##   [1] "Aarts"                            
##   [2] "Acidophiline"                     
##   [3] "Amasi"                            
##   [4] "Ayran"                            
##   [5] "Basundi"                          
##   [6] "Bhuna khoya"                      
##   [7] "Blaand"                           
##   [8] "Blanda (Blanna)"                  
##   [9] "Black Kashk"                      
##  [10] "Booza"                            
##  [11] "Borhani"                          
##  [12] "Buffalo curd"                     
##  [13] "Bulgarian yogurt"                 
##  [14] "Butter"                           
##  [15] "Butterfat"                        
##  [16] "Buttermilk"                       
##  [17] "Buttermilk koldskål"             
##  [18] "Buttermilk powder"                
##  [19] "Cacık"                           
##  [20] "Camel milk"                       
##  [21] "Casein"                           
##  [22] "Caudle"                           
##  [23] "Chaas"                            
##  [24] "Chal"                             
##  [25] "Chalap"                           
##  [26] "Chass"                            
##  [27] "Cheese"                           
##  [28] "Clabber"                          
##  [29] "Clotted cream"                    
##  [30] "Condensed milk"                   
##  [31] "Cottage cheese"                   
##  [32] "Cream"                            
##  [33] "Cream cheese"                     
##  [34] "Crème anglaise"                  
##  [35] "Crème fraîche"                  
##  [36] "Cuajada"                          
##  [37] "Curd"                             
##  [38] "Curd snack"                       
##  [39] "Custard"                          
##  [40] "Dadiah"                           
##  [41] "Daigo"                            
##  [42] "Dondurma"                         
##  [43] "Donkey's milk"                    
##  [44] "Dulce de Leche"                   
##  [45] "Doogh"                            
##  [46] "Evaporated milk"                  
##  [47] "Eggnog"                           
##  [48] "Filled milk"                      
##  [49] "Filmjölk"                        
##  [50] "Fromage frais"                    
##  [51] "Fermented milk products"          
##  [52] "Frozen custard"                   
##  [53] "Frozen yogurt"                    
##  [54] "Gelato"                           
##  [55] "Ghee"                             
##  [56] "Goat milk"                        
##  [57] "Gombe"                            
##  [58] "Gomme"                            
##  [59] "Horse milk"                       
##  [60] "Ice cream"                        
##  [61] "Ice milk"                         
##  [62] "Infant formula"                   
##  [63] "Junket"                           
##  [64] "Junnu"                            
##  [65] "Kalvdans"                         
##  [66] "Kashk, aaruul, chortan, qurut"    
##  [67] "Kaymak"                           
##  [68] "Kefir"                            
##  [69] "Khoa"                             
##  [70] "Kulfi"                            
##  [71] "Kumis"                            
##  [72] "Lassi"                            
##  [73] "Leben (labneh)"                   
##  [74] "Malai"                            
##  [75] "Malaiyo"                          
##  [76] "Matzoon"                          
##  [77] "Milk"                             
##  [78] "Milk skin"                        
##  [79] "Míša"                           
##  [80] "Mitha Dahi"                       
##  [81] "Mozzarella"                       
##  [82] "Moose milk"                       
##  [83] "Mursik"                           
##  [84] "Paneer"                           
##  [85] "PodmleÄ\215"                         
##  [86] "Pomazánkové máslo"             
##  [87] "Powdered milk"                    
##  [88] "Processed cheese"                 
##  [89] "Pytia"                            
##  [90] "Qatiq"                            
##  [91] "Qimiq"                            
##  [92] "Quark"                            
##  [93] "Reindeer milk"                    
##  [94] "Ryazhenka"                        
##  [95] "Ricotta"                          
##  [96] "Sarasson"                         
##  [97] "Semifreddo"                       
##  [98] "Sergem"                           
##  [99] "Sheep milk"                       
## [100] "Shrikhand"                        
## [101] "Skorup"                           
## [102] "Skyr"                             
## [103] "Smen"                             
## [104] "Smetana"                          
## [105] "Snow cream"                       
## [106] "So"                               
## [107] "Soft serve"                       
## [108] "Sour cream"                       
## [109] "Soured milk"                      
## [110] "Spaghettieis"                     
## [111] "Strained yogurt"                  
## [112] "Súrmjólk"                       
## [113] "Sütlaç"                         
## [114] "Tarhana"                          
## [115] "Tuttis"                           
## [116] "Uunijuusto"                       
## [117] "Vaccenic acid"                    
## [118] "Varenets"                         
## [119] "Viili"                            
## [120] "Vla"                              
## [121] "Whey"                             
## [122] "Whey protein"                     
## [123] "Whipped cream"                    
## [124] "Yak butter"                       
## [125] "Yak milk"                         
## [126] "Yakult"                           
## [127] "Yayık ayranı"                   
## [128] "Ymer"                             
## [129] "Yogurt"                           
## [130] "ŽinÄ\215ica"                        
## [131] "Wagasi"                           
## [132] "Ayibe"                            
## [133] "Caravane cheese"                  
## [134] "Chhana"                           
## [135] "Chura kampo"                      
## [136] "Chura loenpa"                     
## [137] "Nguri"                            
## [138] "Rubing"                           
## [139] "Rushan"                           
## [140] "Bandel"                           
## [141] "Paneer"                           
## [142] "Chhana"                           
## [143] "Dahi Chhana"                      
## [144] "Kalari"                           
## [145] "Kalimpong cheese"                 
## [146] "Dangke"                           
## [147] "Sakura cheese"                    
## [148] "Imsil"                            
## [149] "Byaslag"                          
## [150] "Flower of Rajya"                  
## [151] "Chhurpi"                          
## [152] "Kesong puti"                      
## [153] "Djathë i bardhë"                
## [154] "Kaçkavall"                       
## [155] "Djathë pice"                     
## [156] "Gjizë"                           
## [157] "Chechil"                          
## [158] "Bachensteiner"                    
## [159] "Bergkäse"                        
## [160] "Brimsen"                          
## [161] "Gelundener Käse"                 
## [162] "Lüneberg cheese"                 
## [163] "Montafoner Sauerkäse"            
## [164] "Mondseer"                         
## [165] "Staazer"                          
## [166] "Steirerkäse"                     
## [167] "Tyrolean grey (Tiroler Graukäse)"
## [168] "Brussels cheese"                  
## [169] "Chimay cheeses"                   
## [170] "Herve cheese"                     
## [171] "Le Wavreumont"                    
## [172] "Limburger cheese"                 
## [173] "Maredsous cheese"                 
## [174] "Passendale cheese"                
## [175] "Remoudou"                         
## [176] "Rodoric"                          
## [177] "Livno cheese"                     
## [178] "Herzegovina \"squeaking\" cheese" 
## [179] "Trappista cheese"                 
## [180] "VlaÅ¡ić / TravniÄ\215ki cheese"     
## [181] "Bosnian smoked cheese"            
## [182] "Cherni Vit"                       
## [183] "Kashkaval"                        
## [184] "Sirene"                           
## [185] "Paški sir"                       
## [186] "Å kripavac"                       
## [187] "Tounjski"                         
## [188] "Prgica"                           
## [189] "Dimsi"                            
## [190] "Akkawi"                           
## [191] "Anari cheese"                     
## [192] "Halloumi"                         
## [193] "Kefalotyri"                       
## [194] "Abertam cheese"                   
## [195] "Blaťácké zlato"                
## [196] "Olomoucké syreÄ\215ky"              
## [197] "Hermelín"                        
## [198] "Danbo"                            
## [199] "Danish Blue"                      
## [200] "Esrom"                            
## [201] "Fynbo"                            
## [202] "Havarti"                          
## [203] "Maribo"                           
## [204] "Molbo"                            
## [205] "Saga"                             
## [206] "Samsø cheese"                    
## [207] "Tybo"                             
## [208] "Vesterhavsost"                    
## [209] "Banbury cheese"                   
## [210] "Cheddar cheese"                   
## [211] "Stilton Cheese"                   
## [212] "Stinking Bishop Cheese"

##   [1] "Macaroni and Cheese"                                                                                                                      
##   [2] "Cheese Pizza Snack Bites"                                                                                                                 
##   [3] "Cheese"                                                                                                                                   
##   [4] "Strawberry Soy Yogurt"                                                                                                                    
##   [5] "Port Wine Cheese Spread"                                                                                                                  
##   [6] "Tasty Treats Nonpareils Milk Chocolate"                                                                                                   
##   [7] "Flavored Butters"                                                                                                                         
##   [8] "Ranch Greek Yogurt Dressing"                                                                                                              
##   [9] "Ice Cream"                                                                                                                                
##  [10] "Coconut Beverage, Broccoli Cheddar Soup, Eggs, and Cheese Product"                                                                        
##  [11] "PB&J Greek Yogurt Parfaits"                                                                                                               
##  [12] "Precision Blend Time Release Protein Cookies and Cream"                                                                                   
##  [13] "Ice Cream"                                                                                                                                
##  [14] "Colby Jack Cheese"                                                                                                                        
##  [15] "Baked Cheese Lasagna"                                                                                                                     
##  [16] "Chocolate Chocolate Mochi Ice Cream"                                                                                                      
##  [17] "Milk chocolate peanuts, chocolate peanuts, trail mix, sweet and spicy mix"                                                                
##  [18] "Ice Cream"                                                                                                                                
##  [19] "Mango Flavored Ice cream"                                                                                                                 
##  [20] "Yogurt and Granola Parfaits"                                                                                                              
##  [21] "Beans & Cheese Burritos"                                                                                                                  
##  [22] "Cheese"                                                                                                                                   
##  [23] "Cheeses"                                                                                                                                  
##  [24] "Cheese Ravioli Pasta Pick-Ups"                                                                                                            
##  [25] "Monterey Jack Cheese with Jalapeno Peppers"                                                                                               
##  [26] "Cheeses"                                                                                                                                  
##  [27] "Milk Chocolate Big Ear Bunny Sucker"                                                                                                      
##  [28] "Muenster  Cheese"                                                                                                                         
##  [29] "Cheese"                                                                                                                                   
##  [30] "Cheeses"                                                                                                                                  
##  [31] "Cheeses"                                                                                                                                  
##  [32] "Cheese and cheese-containing gift boxes"                                                                                                  
##  [33] "Cheese"                                                                                                                                   
##  [34] "Cheese"                                                                                                                                   
##  [35] "Cheese"                                                                                                                                   
##  [36] "Cheese"                                                                                                                                   
##  [37] "Cheese"                                                                                                                                   
##  [38] "Cheese"                                                                                                                                   
##  [39] "Colby Cheese and Colby Jack Cheese"                                                                                                       
##  [40] "Soureliette Cheese, Tomme Brebis Fedou Cheese"                                                                                            
##  [41] "Nacho Cheese Tortilla chips"                                                                                                              
##  [42] "Macaroni & Cheese Cups"                                                                                                                   
##  [43] "Milk chocolate vanilla carmels (premium chocolate treats flavor)"                                                                         
##  [44] "Ice cream"                                                                                                                                
##  [45] "Gift Baskets containing Blue Cheese Savory Twists"                                                                                        
##  [46] "Express Mac & Cheese, Macaroni & Cheese"                                                                                                  
##  [47] "Mac & Cheese"                                                                                                                             
##  [48] "Sour cream & onion kettle chips"                                                                                                          
##  [49] "Pumpkin Ice Cream Pies"                                                                                                                   
##  [50] "Cheese Manicotti"                                                                                                                         
##  [51] "Grated Cheese"                                                                                                                            
##  [52] "Ice Cream"                                                                                                                                
##  [53] "Ice Cream"                                                                                                                                
##  [54] "Description Ice Cream"                                                                                                                    
##  [55] "Ice Cream"                                                                                                                                
##  [56] "Gelato"                                                                                                                                   
##  [57] "Ice cream products"                                                                                                                       
##  [58] "Manila Sky Purple Yumm Ice Cream"                                                                                                         
##  [59] "Fruit Preserves and Fruit Butter"                                                                                                         
##  [60] "Various flavors of Ice cream containing chocolate chip cookie dough pieces"                                                               
##  [61] "Ice cream in the following flavors: Chocolate Chip Cookie Dough, Cookie Two Step, Blue Monster, Chocolate Chip Cookie, Krazy Kookie Dough"
##  [62] "Chocolate Cookie Dough Ice Cream"                                                                                                         
##  [63] "Dutch Chocolate Ice Cream"                                                                                                                
##  [64] "Milk Baby Food"                                                                                                                           
##  [65] "Ice Cream"                                                                                                                                
##  [66] "Four Goat Cheeses"                                                                                                                        
##  [67] "Milk Chocolate Almond Supremes"                                                                                                           
##  [68] "Almond Butter"                                                                                                                            
##  [69] "Cow Ghee"                                                                                                                                 
##  [70] "Cottage cheese"                                                                                                                           
##  [71] "Cottage cheese"                                                                                                                           
##  [72] "Gouda, Onion ‘n Garlic, Country Dill, Leyden, Edam, Lamont Cheddar, Fait Gras and Polkton Corners Cheeses"                                
##  [73] "Ice Cream"                                                                                                                                
##  [74] "Gouda, Onion ‘n Garlic, Country Dill, Leyden, Edam, Lamont Cheddar, Fait Gras and Polkton Corners Cheeses"                                
##  [75] "Cheese products"                                                                                                                          
##  [76] "Cappuccino Ice cream"                                                                                                                     
##  [77] "Mozzarella Cheese Sticks"                                                                                                                 
##  [78] "Deluxe S'mores Ice Cream"                                                                                                                 
##  [79] "Custard Cake"                                                                                                                             
##  [80] "Ice Cream Dipped \"Variety\" Cones"                                                                                                       
##  [81] "Cheesecakes"                                                                                                                              
##  [82] "Multiple varieties of Muscle Milk"                                                                                                        
##  [83] "Cheesecakes and Key Lime Pies"                                                                                                            
##  [84] "Macaroni Salad with Cheddar Cheese"                                                                                                       
##  [85] "Cheese spread, cookies and cream dessert"                                                                                                 
##  [86] "Rocky Road Ice Cream"                                                                                                                     
##  [87] "Undeclared Milk and Soy Lecithin"                                                                                                         
##  [88] "Milk Chocolate Malt Balls"                                                                                                                
##  [89] "Asparagus, Pea & Ricotta Salad"                                                                                                           
##  [90] "Cinnamon Rolls with Cream Cheese Icing"                                                                                                   
##  [91] "Yogurt Super Soynuts"                                                                                                                     
##  [92] "Whole Milk and Low Fat Yogurt"                                                                                                            
##  [93] "Cheese & Fruit Bistro Box"                                                                                                                
##  [94] "Sausage, Egg, and Cheddar Cheese on English Muffin breakfast sandwiches"                                                                  
##  [95] "Cheese"                                                                                                                                   
##  [96] "Cheese"                                                                                                                                   
##  [97] "Cheese"                                                                                                                                   
##  [98] "Cheese"                                                                                                                                   
##  [99] "Cheese"                                                                                                                                   
## [100] "Organic Coconut Milk Powder and various products (e.g. hot chocolate, pudding, cereal) containing the Organic Coconut Milk Powder."       
## [101] "Margaritaville Banana Cream Pie Filling"                                                                                                  
## [102] "H-E-B Creamy Creations Caramel Pecan Turtle Ice Cream"                                                                                    
## [103] "Ice Cream"                                                                                                                                
## [104] "Milk Chocolate/Dark Chocolate/Yogurt Covered Cranberry Blend"                                                                             
## [105] "Macaroni and Cheese products"                                                                                                             
## [106] "Chocolate Ice Cream"                                                                                                                      
## [107] "Cheese Dip"                                                                                                                               
## [108] "Cheese Dip"                                                                                                                               
## [109] "Cheese Dip"                                                                                                                               
## [110] "Cheese Dip"                                                                                                                               
## [111] "Cheese Dip"                                                                                                                               
## [112] "Cheese Dip"                                                                                                                               
## [113] "Blue Cheese Salmon Burgers"                                                                                                               
## [114] "Five Cheese Stuffed Shells"                                                                                                               
## [115] "Raspberry Cheesecake Italian Gelato"                                                                                                      
## [116] "Cheese Nips"                                                                                                                              
## [117] "Cottage Cheese"                                                                                                                           
## [118] "Peppermint Pattie Ice Cream"                                                                                                              
## [119] "Dorset, Slyboboro and Experience Cheeses"                                                                                                 
## [120] "Sea Salt Caramels Tumbled In Milk Chocolate"                                                                                              
## [121] "Cheese Ravioli Pasta Pick-Ups"                                                                                                            
## [122] "Cheese biscuits"                                                                                                                          
## [123] "Milk Chocolate Big Ear Bunny Sucker"                                                                                                      
## [124] "Ice Cream"                                                                                                                                
## [125] "Ranch Greek Yogurt Dressing"                                                                                                              
## [126] "Cream Cheese Cinnamon Rolls"                                                                                                              
## [127] "Ice Cream"                                                                                                                                
## [128] "Yogurt Raisins"                                                                                                                           
## [129] "Flavored Butters"                                                                                                                         
## [130] "Ice Cream"                                                                                                                                
## [131] "PB&J Greek Yogurt Parfaits"                                                                                                               
## [132] "Cheeses, breads, and desserts"                                                                                                            
## [133] "Cheeses, breads, and desserts"                                                                                                            
## [134] "Cheesecake bars"                                                                                                                          
## [135] "Macaroni and Cheese"                                                                                                                      
## [136] "Cheese Pizza Snack Bites"                                                                                                                 
## [137] "Milk chocolate peanuts, chocolate peanuts, trail mix, sweet and spicy mix"                                                                
## [138] "Chocolate Gooey Brownie Ice Cream"                                                                                                        
## [139] "Ice Cream"                                                                                                                                
## [140] "Chocolate Chocolate Mochi Ice Cream"                                                                                                      
## [141] "Baked Cheese Lasagna"                                                                                                                     
## [142] "Milk Chocolate Flavored Coated Wafer with Hazelnut Crème Filling and White Chocolate Flavor"                                              
## [143] "Frozen yogurt"                                                                                                                            
## [144] "Yogurt and Granola Parfaits"                                                                                                              
## [145] "Strawberry Soy Yogurt"                                                                                                                    
## [146] "Gluten Free Cookies N Cream Ice Cream"                                                                                                    
## [147] "Yogurt Pretzels"                                                                                                                          
## [148] "Red Velvet Cheesecake slices"                                                                                                             
## [149] "Unsalted Butter"                                                                                                                          
## [150] "Cheese"                                                                                                                                   
## [151] "Salvadorean String Cheese (Quesillo Cheese) semi-soft cheese"                                                                             
## [152] "Mecox Sunrise Cheese"                                                                                                                     
## [153] "Cheeses"                                                                                                                                  
## [154] "Old Fashioned Pimento Cheese"                                                                                                             
## [155] "Ackawi Cheese"                                                                                                                            
## [156] "Cheese"                                                                                                                                   
## [157] "Cheeses"                                                                                                                                  
## [158] "Coconut Beverage, Broccoli Cheddar Soup, Eggs, and Cheese Product"                                                                        
## [159] "Pasteurized Cow’s Milk Cheese"                                                                                                            
## [160] "Cheeses"                                                                                                                                  
## [161] "Cheeses"                                                                                                                                  
## [162] "Cheese"                                                                                                                                   
## [163] "Cheese and cheese-containing gift boxes"                                                                                                  
## [164] "Cheese"                                                                                                                                   
## [165] "Monterey Jack Cheese with Jalapeno Peppers"                                                                                               
## [166] "Cheese"                                                                                                                                   
## [167] "Cheese"                                                                                                                                   
## [168] "Port Wine Cheese Spread"                                                                                                                  
## [169] "Cheese"                                                                                                                                   
## [170] "Cheese"                                                                                                                                   
## [171] "Cream Cheese"                                                                                                                             
## [172] "Cheese 1 lb wheel"                                                                                                                        
## [173] "Cheesecake"                                                                                                                               
## [174] "Tasty Treats Nonpareils Milk Chocolate"                                                                                                   
## [175] "Ice cream and sherbet"                                                                                                                    
## [176] "Dry Whey Powder"                                                                                                                          
## [177] "Soureliette Cheese, Tomme Brebis Fedou Cheese"                                                                                            
## [178] "Cheese"                                                                                                                                   
## [179] "Colby Cheese and Colby Jack Cheese"                                                                                                       
## [180] "Cheese"                                                                                                                                   
## [181] "Raw Goat Milk Cheese"                                                                                                                     
## [182] "Cheese"                                                                                                                                   
## [183] "Creamy Creations ice creams and sherbets"                                                                                                 
## [184] "Mango Flavored Ice cream"                                                                                                                 
## [185] "Ice Cream"                                                                                                                                
## [186] "No Sugar Added Ice Cream (Vanilla; Chocolate flavors)"                                                                                    
## [187] "Orange Cream Bars"                                                                                                                        
## [188] "Raspberry Cream Bars"                                                                                                                     
## [189] "Beans & Cheese Burritos"                                                                                                                  
## [190] "Turkey and Cheese Wedge Sandwiches"                                                                                                       
## [191] "Salsa Con Queso Mild Cheese Dip"                                                                                                          
## [192] "Greek and Low Fat Yogurts"                                                                                                                
## [193] "Fruit Puree with Nonfat Greek Yogurt pouch"                                                                                               
## [194] "Butter Crunch Ice Cream"                                                                                                                  
## [195] "Banana Puddin’ Ice Cream"                                                                                                                 
## [196] "Ice Cream"                                                                                                                                
## [197] "Mint Chocolate Chip with Hidden Spinach Ice Cream"                                                                                        
## [198] "Advantage Infant Formula Milk Based Powder with Iron"                                                                                     
## [199] "2% Reduced Fat Vanilla Half Gallon Milk"                                                                                                  
## [200] "Frozen Cheeseburger and hamburger sliders"                                                                                                
## [201] "Precision Blend Time Release Protein Cookies and Cream"                                                                                   
## [202] "Italian Sub and Ham & Cheese Sandwiches and Ham & Swiss Croissants"                                                                       
## [203] "Marketside Brand Creamy Cauliflower Parmesan Soup"                                                                                        
## [204] "Baked Potatoes with Cheddar Cheese and Bacon"                                                                                             
## [205] "Greek Crunch S'mores Nonfat Yogurt"

• Ensure proper procedures for Listeria monocytogenes
• Make sure allergens are last in shift, label change out is critical control point